package org.tity.sql.sql;

import static org.junit.Assert.assertTrue;

import java.util.ArrayList;
import java.util.List;

import org.junit.Test;
import org.tity.sql.sql.builder.CE;
import org.tity.sql.sql.builder.Delete;
import org.tity.sql.sql.builder.In;
import org.tity.sql.sql.builder.SE;
import org.tity.sql.sql.builder.Update;
import org.tity.sql.sql.builder.Where;

import com.alibaba.fastjson.JSON;

public class CEAdvanceTest {

	@Test
	public void test_ignor3() {
		
		CE e1=new CE("f0=?",11);
		
	 
		e1.andEquals("f1", "%","%");
		e1.andEquals("f2", "","");
		
		e1.andNotEquals("f3", null);
		e1.andLike("f4", "%%%%");
		
		e1.ignore("ALL").andLike("f5", "ALL");

		e1.andNotContains("f6", "rt", "rr","rt");
		
		e1.andNotContains("f7", "rt", "rr","rct");
		
		System.out.println("ignor-1 result "+e1.getSQL());
		
 
		assertTrue(!e1.getSQL().contains("f1"));
		assertTrue(!e1.getSQL().contains("f2"));
		assertTrue(!e1.getSQL().contains("f3"));
		assertTrue(!e1.getSQL().contains("f4"));
		assertTrue(!e1.getSQL().contains("f5"));
		assertTrue(!e1.getSQL().contains("f6"));
		assertTrue(e1.getSQL().contains("f7"));
	}

}
